import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;


/**
 * Created with IntelliJ IDEA.
 * User: Jason
 * Date: 6/4/13
 * Time: 6:23 PM
 * To change this template use File | Settings | File Templates.
 *
 * //Currently not in used. Testing to centralize DB access
 */
public class InitDb {

    public void initdbli(){
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            //Connection to Hicksville
            String dataSourceName = "dbLI";
            String dbURL = "jdbc:odbc:" + dataSourceName;
            Connection connection = DriverManager.getConnection(dbURL, "", "");
            Statement stmt = connection.createStatement();
        }catch (SQLException e){

        } catch (ClassNotFoundException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
    }

    public void initdbBk()  {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            //Connection to Hicksville
            String dataSourceName = "dbLI";
            String dbURL = (new StringBuilder()).append("jdbc:odbc:").append(dataSourceName).toString();
            Connection connection = DriverManager.getConnection(dbURL, "", "");
            Statement stmt = connection.createStatement();
        }catch (SQLException e){

        } catch (ClassNotFoundException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
    }
}